Page Control Search – Dynamics 365 BC Table Reference

SELECT p.ID ,p.Name ,pc.ControlName ,post.post_name FROM azrcrv_PageControls AS pc INNER JOIN azrcrv_Pages AS p ON p.ID = pc.PageNo INNER JOIN bct_posts AS post ON post.post_title = p.Name WHERE pc.ControlName = 'Bank Account No.' ORDER BY p.ID ,pc.ControlName

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to BANK ACCOUNT NO.

Seq No	Page Number	Page Name	Control Name
1	1	Company Information	Bank Account No.
2	1	Company Information	Bank Account No.
3	165	Bank Acc. Ledg. Entr. Preview	Bank Account No.
4	270	Online Bank Accounts	Bank Account No.
5	370	Bank Account Card	Bank Account No.
6	371	Bank Account List	Bank Account No.
7	372	Bank Account Ledger Entries	Bank Account No.
8	374	Check Ledger Entries	Bank Account No.
9	383	Bank Account Statement	Bank Account No.
10	383	Bank Account Statement	Bank Account No.
11	389	Bank Account Statement List	Bank Account No.
12	423	Customer Bank Account Card	Bank Account No.
13	424	Customer Bank Account List	Bank Account No.
14	425	Vendor Bank Account Card	Bank Account No.
15	426	Vendor Bank Account List	Bank Account No.
16	1231	Positive Pay Entries	Bank Account No.
17	1232	Positive Pay Entry Details	Bank Account No.
18	1234	Positive Pay Export Detail	Bank Account No.
19	1283	Payment Bank Account Card	Bank Account No.
20	1293	Pmt. Rec. Journals Overview	Bank Account No.
21	1294	Pmt. Reconciliation Journals	Bank Account No.
22	1295	Posted Payment Reconciliation	Bank Account No.
23	1299	Posted Payment Reconciliations	Bank Account No.
24	1690	Bank Deposit	Bank Account No.
25	1691	Bank Deposit List	Bank Account No.
26	1692	Bank Deposits	Bank Account No.
27	1694	Posted Bank Deposit	Bank Account No.
28	1696	Posted Bank Deposit List	Bank Account No.
29	1803	Assisted Company Setup Wizard	Bank Account No.
30	2137	O365 Bank Information Settings	Bank Account No.
31	5200	Employee Card	Bank Account No.
32	8629	Config. Wizard	Bank Account No.
33	20106	AMC Bank Assist Bank Account	Bank Account No.

Dynamics 365 BC Table ReferencePage Control Search